set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procTest_Log_Answer_get_Selected](
@Test_Log_No as int,
@Test_Log_Line as int
)
AS
BEGIN 
SELECT     Answer.Description, Answer.ID, Answer.Explanation
FROM         Test_Log_Answer INNER JOIN
                      Answer ON Test_Log_Answer.Answer_ID = Answer.ID
WHERE     (Test_Log_Answer.Test_Log_No = @Test_Log_No) AND (Test_Log_Answer.Test_Log_Line = @Test_Log_Line) AND (Test_Log_Answer.Answer_Selected = 1)
END


